Disclaimer
The information presented in this lecture is for educational and informational purposes only and should not be construed as investment advice. Nothing discussed constitutes a recommendation to buy, sell, or hold any financial instrument or security. Investment decisions should be made based on individual research and consultation with a qualified financial professional. The presenter assumes no responsibility for any financial decisions made based on this content.
All publicly available content used in this lecture is available and also shared on my GitHub page. Participants are encouraged to review, modify, and use it for their own learning and research purposes. However, no guarantees are made regarding the accuracy, completeness, or suitability of the code for any specific application.
For any questions or concerns, please feel free to reach out via email at lucas.macoris@fgv.br
As you saw in the previous lecture, although Relative Valuation can provide a ballpark estimate of what would have been the firm value as-if it was priced similarly to other comparable firms, there were a series of drawbacks and limitations:
To that matter, we need a way to estimate the intrinsic value of a company taking into account specific information regarding its ability to generate future profits
So far, we’ve been concerned about the firm’s past performance:
Now, we’ll turn our attention to focus on (expected) future performance:
In what follows, you will learn how to estimate the future cash-flows that will serve as a input to our analysis!
Definition
Valuation method that estimates the present value of an asset based on its expected future cash flows.. It takes into account measures of expected profits (\(\small 1,2,...,\infty\) periods ahead) and its underlying risk to come up with an estimate of the opportunity value in \(\small t_0\).
\[ V_i = \sum_{t=1}^{\infty} \dfrac{CF_i}{(1+r_i)}, \]
where \(r_i\) is the opportunity cost of capital associated with undertaking the project
Question: how can we use such rationale to estimate the value of a new investment opportunity?
Definition
The Free Cash Flow is a measure of the project’s available cash to be repaid to its investors after all costs and investments needed to sustain the business plan were taken into account. It is calculated by:
Cia. Amazônia is a manufacturer of sports shoes that is analyzing the possibility of investing in a new line of sneakers, having even incurred research and market testing costs worth \(\small \$125,000\). The shoes would be manufactured in a warehouse next to the company’s factory, fully depreciated, which is vacant and could be rented for \(\small\$38,000\) per year.
The cost of the machine is \(\small \$200,000\), depreciated over five years using the straight-line method. Its market value, estimated at the end of five years, is \(\small \$35,000\)
The company needs to maintain a certain investment in working capital. As it is an industrial company, it will purchase raw materials before producing and selling the final product, which will result in an investment in inventories. The firm will maintain a cash balance as protection against unforeseen expenses. Credit sales will generate accounts receivable. In sum, working capital will represent \(\small10\%\) of sales revenue.
The company projects the following sales over a \(\small5\)-year horizon
The unit price is \(\small\$28\), and the unit cost is \(\small\$14\). It is estimated that its operating costs will rise at an average rate of \(\small6\%\) each year
On the other hand, the company knows that due to market competition, it will not be able to fully pass this on to prices and projects an average increase in sales prices of \(\small4\%\) each year
Earnings are not actual cash flows. However, as a practical matter, to derive the forecasted cash flows of a project, financial managers often begin by forecasting earnings
Thus, we begin by determining the incremental earnings of a project—that is, the amount by which the firm’s earnings are expected to change as a result of the investment decision.
In our case, we begin by determining the direct earnings and cost estimates from the operation:
\[ \small \text{Gross Profit}_{t}=\text{Sales}_t\times(\text{Price per Unit}_t-\text{Cost per Unit}_t) \]
Before we calculate tax expenses, we need to deduct all other costs that may affect taxes:
When computing the incremental earnings of an investment decision, we should include all changes between:
There are two important sources of indirect costs that need to be considered:
Opportunity Costs: many projects use a resource that the company already owns. However, in many cases the resource could provide value for the firm in another opportunity or project.
Project externalities: indirect effects of the project that may increase or decrease the profits of other business activities of the firm
In our case, we saw that the firm will use existing assets that otherwise would yield $38,000 yearly. Because of that, we need to take into consideration as an opportunity cost
What about the \(\small\$125,000\) R&D expenses incurred? This is an example of a sunk cost:
Examples of sunk costs may include, but are not limited to: past R&D expenses, fixed overhead costs, and unavoidable competition effects
\[ \small EBIT_{t}= [\text{Sales}_t\times(\text{Price per Unit}_t-\text{Cost per Unit}_t)-\text{Depreciation}_t-\text{Other Costs}_t] \]
\[ \small \text{Income Tax}_{t}= EBIT_{t}\times\tau_t \]
What if part of the upfront investment was financed using debt? Do we need to include interest expenses in the calculation?
Because the Free Cash Flow is the measure of available resources to all investors of the firm (creditors + equityholders), whenever we evaluating a capital budgeting decision, we do not include interest expenses in the calculation
\(\rightarrow\) Therefore, in our Free Cash Flow estimations, we’ll be focusing on the operating portion as if it were financed without any debt!
There are important differences between earnings and cash flow:
To determine the Free Cash Flow, we must adjust for these differences by:
For Depreciation, we need to add back \(\small\$50,000\) across Year 1-5 to account for non-cash items
On the other hand, to consider the actual cost of the machinery by the time that it was bought, we need to include \(\small\$200,000\) in Year 0 of the analysis
Now that we have considered all cash effects from the investment that is needed, is there anything else that needs to be taken into consideration?
Most projects will require the firm to continuosly invest in net working capital as time goes by:
Although it is difficult to consider all potential fluctuations on working capital, it is expected that a portion of it should be positively correlated with sales:
In our case, we summarized this idea by taking into consideration that working capital is 10% of the Sales revenue
Therefore, our year-over-year change in net working capital reflects the additions/deductions on the amount of net working capital for each year:
\[ \small \Delta NWC_{t}=NWC_{t}-NWC_{t-1} \]
In the beginning of Year 0, we forecast Year 1’s sales and invest in working capital
For each Year 1-4, we look forward to period \(\small t+1\) to determine the adequate level of working capital in \(t\)
At the end of Year 5, we know that the \(\small NWC=0\), assuming that the project ends
Therefore, \(\small \Delta NWC_{t=5}\) shows that the firm can recover its investment in working capital
(+) Revenues
(-) Costs
(-) Depreciation
(=) EBIT
(-) Tax Expenses
(=) Unlevered Net Income
(+) Depreciation
(-) CAPEX
(-) \(\Delta\) NWC
(=) Free Cash Flow
\[ \small FCF_{t}= \underbrace{(\text{Revenues}-\text{Costs}-\text{Depreciation})\times(1-\tau)}_{\text{Unlevered Net Income}}+\text{Depreciation}-\text{CAPEX}-\Delta NWC \]
Note that we first deduct depreciation when computing the project’s incremental earnings, and then add it back (because it is a non-cash expense) when computing Free Cash Flow
Thus, the only effect of depreciation is to reduce the firm’s taxable income!
Because of this, we can rewtrite the same equation as:
\[ \small FCF_{t}= (\text{Revenues}-\text{Costs})\times(1-\tau)-\text{CAPEX}-\Delta NWC+\tau\times\text{Depreciation} \]
Our final step is to account for any eventual adjustments needed. Some examples include (but are not limited) to:
In our case, we know that the market-value of the machinery is \(\small 35,000\). Since it has been fully depreciated at Year 5, we know that the capital gain is simply \(\small 35,000 - 0 = 35,000\)
Therefore, we also need to consider that, in Year 5, as the project has ended, we can sell the machine, pay taxes on it, and recover part the liquidation value of our investment:
\[ \small \text{Liquidation Value}= 35,000 \times (1-\tau)\rightarrow 35,000\times(1-34\%)=23,100 \]
\[ \small FCF_{t=5}=107,584+23,100=130,684 \]
\[ \small NPV= \dfrac{-219,000}{(1+15\%)^0}+\dfrac{46,592}{(1+15\%)^1}+\dfrac{69,266}{(1+15\%)^2}+\dfrac{80,218}{(1+15\%)^3}+\dfrac{101,293}{(1+15\%)^4}+\dfrac{130,684}{(1+15\%)^5}=48,922.22 \]
What else needs to be done? See the Appendix for a detailed discussion on some of the most common adjustments and extensions1:
\(\rightarrow\) All contents are available on eClass®.
Suppose that instead of using foreign suppliers when buying your machinery, you have received an offer to use new, national supplier, which can provide machinery that is supposedly as efficient as the original one. Notwithstanding, because you’re financing a national capital good, you have access to an accelerated depreciation benefit:
Would you accept the offer?
\(\rightarrow\) Answer provided in Excel
Suppose that instead of having the previous accelerated depreciation alternative, you have received a more aggressive one: depreciate 100% of the machine in the first year. You also notice that you can deduct your taxable income with tax carryforward up to a limit of 30% of the taxable income. Calculate the new NPV of the project and discuss how it has changed.
\(\rightarrow\) Answer provided in Excel
In our standard setting, our assumption was that the firm’s operation would cease after Year 5. Because of that, we initially included in our Free Cash Flow estimates a Termination Value that represented the sale of unused assets, after taking into account its tax effects.
Suppose that the firm is able to continue its operations indefinitely after Year 5, and that the FCF is expected to stay the same as of Year 5. Calculate the new NPV of the project assuming the same cost of capital. Justify why the values have changed significantly.
How your answer would change if the FCF grew at a 2% rate after Year 5, indefinitely?
\(\rightarrow\) Answer provided in Excel
The most difficult part of capital budgeting is deciding how to estimate the cash flows and cost of capital. Unfortunately, these estimates are often subject to significant uncertainty:
How we can assess the importance of this uncertainty and identify the drivers of value in the project?
In what follows, we’ll look at some examples outlining ways to incorporate uncertainty in our valuation model
Shareholders at Cia Amazônia are concerned that rising costs of activity may hinder any profitable investment opportunity projected in the original project. More specifically, their main concern is that the average growth rate in Unit Costs, which was estimated to be 6%, is estimated using very unreasonable scenario, and that higher increases in unit costs might induce the project’s NPV to be negative. Estimate what is the maximum average increase in unit costs over the years that would change the decision to invest in the project.
\(\rightarrow\) Answer provided in Excel
Shareholders might be reluctant to trust the NPV estimates if they are unable to understand which drivers potentially affect more the value of the project in best and worst-case situations. Consider that you now have three scenarios: base, worst, and best case scenarios. In each one, you have the following configuration:
Base: the baseline exercise from Cia Amazônia. Growth rate of Unit Costs: \(\small4\%\); Growth rate of Unit Prices: \(\small6%\); Cost of Capital: \(\small15\%\)
Worst: Growth rate of Unit Costs: \(\small0%\); Growth rate of Unit Prices: \(\small10\%\); Cost of Capital: \(\small19\%\)
Best: Growth rate of Unit Costs: \(\small10\%\); Growth rate of Unit Prices: \(\small1\%\); Cost of Capital: \(\small10\%\)
Estimate how your NPV estimates change along with your inputs, each one at a time, and identify which input is more important for the project’s NPV.
\(\rightarrow\) Answer provided in Excel
What if you want to vary over more than one input at a time? Say that, for example, you want to think about a combination of growth rates for unit costs AND unit revenues at the same time? It is very reasonable to assume that more than one driver is going to change at a time. To do that, create a 3x3 grid of combinations considering the growth rates of Unit Costs and Unit Price and show how your NPV estimates change for each pair of growth rate estimates.
\(\rightarrow\) Answer provided in Excel